from openpyxl import load_workbook
workbook=load_workbook(filename='D:\\sms\\python02\\工作.xlsx')
sheet=workbook.active
# sheet.insert_cols(idx=3,amout=3)
# 插入列
# sheet.insert_rows(idx=3,amount=3)
#插入行
# sheet.delete_cols(idx=2,amount=2)
#删除列
sheet.move_range("A5:B8",rows=1,cols=1)
workbook.save(filename='D:\\sms\\python02\\工作.xlsx')
